﻿CREATE TABLE [dbo].[Asset] (
    [Id]                      UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [Name]                    NVARCHAR (50)    NOT NULL,
    [SerialNumber]            NVARCHAR (50)    NOT NULL,
    [Number]                  NVARCHAR (50)    NULL,
    [Type]                    NVARCHAR (50)    NULL,
    [Model]                   NVARCHAR (50)    NULL,
    [Lifespan]                INT              NULL,
    [SalvageValue]            MONEY            NULL,
    [NetBookValue]            MONEY            NULL,
    [DepreciationMonthly]     MONEY            NULL,
    [DepreciationMonths]      INT              NULL,
    [CurrentOwnerId]          UNIQUEIDENTIFIER NULL,
    [CurrentProjectId]        UNIQUEIDENTIFIER NULL,
    [CurrentSubOfficeId]      UNIQUEIDENTIFIER NULL,
    [CurrentWareHouseId]      UNIQUEIDENTIFIER NULL,
    [InventoryId]             UNIQUEIDENTIFIER NOT NULL,
    [GoodsReceivedNoteItemId] UNIQUEIDENTIFIER NULL
);

